﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace KingerRobot.PCRMES.Dao;
partial class Db : K8.EF.DbContext
{
    /// <summary>
    ///Orcale：同步I_WMS_ORDER锁定信息
    /// </summary>
    public DbSet<i_wms_order> WmsOrders { get; set; }
}
/// <summary>
/// MES 钢圈出库指令表
/// </summary>
[Table("i_wms_order")]
public class i_wms_order
{

    /// <summary>
    /// 单号
    /// </summary>
    [Key]
    [Column("list_no")]
    public string LIST_NO { get; set; }
    /// <summary>
    /// 物料编码
    /// </summary>
    [Column("part_number")]
    public string PART_NUMBER { get; set; }
    /// <summary>
    /// 等级 
    /// </summary>
    [Column("grade")]
    public string GRADE { get; set; }
    /// <summary>
    /// 需求数量 
    /// </summary>
    [Column("require_qty")]
    public double? REQUIRE_QTY { get; set; }
    /// <summary>
    /// 任务数量 
    /// </summary>
    [Column("act_qty")]
    public double? ACT_QTY { get; set; }
    /// <summary>
    /// 已发数量 
    /// </summary>
    [Column("ship_qty")]
    public double? SHIP_QTY { get; set; }
    /// <summary>
    /// 终止标志（Y:已终止，N:未终止） 
    /// </summary>
    [Column("stop_flag")]
    public string STOP_FLAG { get; set; }
    /// <summary>
    /// 异常标志
    /// </summary>
    [Column("err_flag")]
    public string ERR_FLAG { get; set; }
    /// <summary>
    /// 备注
    /// </summary>
    [Column("remarks")]
    public string REMARKS { get; set; }
    /// <summary>
    /// 批次号码，默认值0
    /// </summary>
    [Column("batch_name")]
    public string BATCH_NAME { get; set; }
    /// <summary>
    /// 物料组
    /// </summary>
    [Column("part_class")]
    public string PART_CLASS { get; set; }
    /// <summary>
    /// 到目的机台
    /// </summary>
    [Column("target_equip")]
    public string TARGET_EQUIP { get; set; }
    /// <summary>
    /// 创建时间
    /// </summary>
    [Column("create_time")]
    public DateTime? CREATE_TIME { get; set; }
    /// <summary>
    /// 创建人员
    /// </summary>
    [Column("create_user")]
    public string CREATE_USER { get; set; }
    /// <summary>
    /// 更新时间
    /// </summary>
    [Column("last_modified_time")]
    public DateTimeOffset? LAST_MODIFIED_TIME { get; set; }
    /// <summary>
    /// 更新人员
    /// </summary>
    [Column("last_modified_user")]
    public string LAST_MODIFIED_USER { get; set; }
    /// <summary>
    /// 更新标志 1:新增  2:删除 0;复位
    /// </summary>
    [Column("update_flag")]
    public int? UPDATE_FLAG { get; set; }
    /// <summary>
    /// 同步结果，若有错误则写入此字段，成功为空
    /// </summary>
    [Column("error_infor")]
    public string ERROR_INFOR { get; set; }
    /// <summary>
    /// 成型物料编号
    /// </summary>
    [Column("mpartnumber")]
    public string MPARTNUMBER { get; set; }
    /// <summary>
    /// 成型物料版本
    /// </summary>
    [Column("mpartrevision")]
    public string MPARTREVISION { get; set; }
    /// <summary>
    /// 追踪号
    /// </summary>
    [Column("tracecode")]
    public string TRACECODE { get; set; }
    /// <summary>
    /// 要料区域
    /// </summary>
    [Column("area_name")]
    public string AREA_NAME { get; set; }
    /// <summary>
    /// 目标货位
    /// </summary>
    [Column("innerdiameter")]
    public decimal? Innerdiameter { get; set; }

}

